home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Gigarom 4
/
Mac Giga-ROM 4.0 - 1993.toast
/
FILES
/
BUS
/
A-E
/
BASIC BILLING.sea
/
BASIC BILLING
/
Billing
(
.txt
)
next >
Wrap
FileMaker Pro Database
|
1990-11-03
|
40KB
|
292 lines
PLEASE PAY
HBAM2001MAY84
123-4567
765-4321
Apartments
Bambi
Crossing
Drive
Drive
Deerfield
Deerhaven
12345
54321
Antler
Cleaner
Fur-so-soft
Haunches
Shampoo
Company
Address
Address
State
Company
Telephone
4.01I
11/3/90
ACCOUNTNO
ADDRESS 1
ADDRESS 2
AMT PAID
CITY STATE
COMPADDR1
COMPADDR2
COMPCITYSTATEZIP
COMPNAME
COMPPHONE
CURRENT
CURRENTSUM
DESCRIPTION
INVOICE DATE
INVOICE NO
NINETY
$ NINETYSUM
ONE_TWENTY
ONE_TWENTYSUM
PHONE
PLEASE PAY
QUANTITY
REF DATE
SIXTY
SIXTYSUM
STMT AMT PAID
STMT PLEASE PAY
STMT TAX DUE
STMT TOTAL DUE
STMT TOTALPLUSTAX
TAXDUE
TAXRATE
THIRTY
" THIRTYSUM
TOTAL
TOTAL DUE
TOTALPLUSTAX
PhoneB
A AccountNoB
Customers
NameB
Customers
A Address 1B
Customers
A Address 2B
Customers
City StateB
Customers
Customers
Invoice NoB
Invoice DateB
DescriptionB
QuantityB
RateB
TotalB
round(Quantity * Rate,2)F
Amt PaidB
Please PayB
TotalPlusTax- Amt PaidF
A Total DueB
sum(Total)F
TaxRateB
Company Data
TaxDueB
round(TaxRate * Total Due,2)F
TotalPlusTaxB
Total Due + TaxDueF
Stmt Total DueB
Stmt Tax DueB
Stmt TotalPlusTaxB
Stmt Amt PaidB
Stmt Please PayB
CompNameB
Company Data
A CompAddr1B
Company Data
A CompAddr2B
Company Data
CompCityStateZipB
Company Data
A CompPhoneB
Company Data
Ref DateB
E:if(REF DATE - Invoice Date > 0, REF DATE - Invoice Date,0)F"
CurrentB
if(Age <30,Please Pay,0)F
ThirtyB
E&if(Age >=30 and Age < 60,Please Pay,0)
SixtyB
E)if(Age >= 60 and Age <= 90, Please Pay,0)F(
NinetyB
E)if(Age >= 90 and Age < 120, Please Pay,0)F(
One_TwentyB
if(Age >= 120, Please Pay, 0)F
CurrentSumB
'A ThirtySumB
SixtySumB
)A NinetySumB
One_TwentySumB
STATEMENT
DATE: //
DATE
NUMBER
DESCRIPTION
PRICE EA.
TOTAL
SUB TOTAL
TOTAL DUE
PAYMENT
BALANCE DUE
STATEMENT
DATE: //
DATE
NUMBER
DESCRIPTION
PRICE EA.
TOTAL
SUB TOTAL
TOTAL DUE
PAYMENT
BALANCE DUE
INVOICE
DATE:
DESCRIPTION
PRICE EA.
TOTAL
SUB TOTAL
TOTAL DUE
PAYMENT
BALANCE DUE
INVOICE
DATE:
DESCRIPTION
PRICE EA.
TOTAL
SUB TOTAL
TOTAL DUE
PAYMENT
BALANCE DUE
DATE:
SubTtl
Acct. No.
Total
Payment
Balance
DESCRIPTION
PRICE EA.
TOTAL
DATE:
SubTtl
Acct. No.
Total
PLEASE PAY
Payment
Balance
DESCRIPTION
PRICE EA.
TOTAL
AGING REPORT
Account
Current
30 Days
60 Days
90 Days
120 Days
Total Due
Totals
Page ##
AGING REPORT
Account
Current
30 Days
60 Days
90 Days
120 Days
Total Due
Totals
Page ##
Enter the aging date
then press Command =
At the prompt, click on Replace.
Enter the aging date
then press Command =
At the prompt, click on Replace.
123-4567B
John DoeD
123 Deer Crossing Drive.F
Deerhaven, DEG
12345H
1/1/91J
Antler Wax
Hoof CleanerK
1.25M
6.25O
10.06P
8.75Q
1.31S
10.06Y
Company Name Goes HereZ Address 1[ Address 2\
City State and Zip]
Company Telephone^
1/31/91`
10.06c
765-4321B
2C Jane BuckD
No. 1 Bambi ApartmentsE
789 Fawn DriveF
Deerfield, DEG
54321H
1/1/91J
Fur-So-SoftK
11.50O
11.5Y
Company Name Goes HereZ Address 1[ Address 2\
City State and Zip]
Company Telephone^
1/31/91`
123-4567B
John DoeD
123 Deer Crossing Drive.F
Deerhaven, DEG
12345H
11/3/90J
Head & Haunches ShampooK
2.75M
8.25N
9.49O
8.25Q
1.24S
9.49Y
Company Name Goes Here
Z Address 1[ Address 2\
City State and Zip]
Company Telephone^
Create Invoice
sample
Print Invoice
sample
Print Statements
Age Accounts
Print Aging Report
'bQa2
4.01F#
4.01I
11/3/90
ACCOUNTNO
ADDRESS 1
ADDRESS 2
AMT PAID
CITY STATE
COMPADDR1
COMPADDR2
COMPCITYSTATEZIP
COMPNAME
COMPPHONE
CURRENT
CURRENTSUM
DESCRIPTION
INVOICE DATE
INVOICE NO
NINETY
$ NINETYSUM
ONE_TWENTY
ONE_TWENTYSUM
PHONE